"Alerted.org

Job Description

Insight Global is seeking a Senior SQL Server Database Developer is the enterprise expert for designing, developing, and optimizing data processing systems and pipelines used to populate data into transactional databases, data warehouses, data marts, or other data repositories. A Senior SQL Server Database Developer builds systems to create and optimize data sets and data systems for operating applications, performing analysis, or identifying business or technology issues. You will be responsible for operational support and incident/problem management, from creating logging instrumentation to analysis and process improvements. They also coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems.

The Day-to-Day:

Use Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and delivering enterprise data asset solutions in collaboration with business intelligence teams, our users, or other IT teams

Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software

Design, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data files

Develop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a variety of platforms

Coordinate security, application monitoring, development tooling, and related capabilities with responsible teams

Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered

Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs

Train junior data and business intelligence personnel across the company, including developing material, mentoring, and guiding junior personnel on their technical skill growth

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

10+ years of SQL Server Database Development Experience

SQL Server needs to be the database they are developing in

Advanced knowledge of Extract/Transform/Load (ETL) and/or Extract/Load/Transform (ELT) tools, including both batch and real-time data transmission applications. Can be any of these - SSIS, Informatica, Kafka, Spark, MuleSoft, or equivalent software

4+ years of Azure experience

This is technically a plus, but highly preferred. Think Azure IaaS and PaaS, .Net, TQL, Azure SQL, Azure Storage, Azure Data Factory, Cosmos DB, GitHub, Azure Devops, CICD pipelines null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].