Senior Azure Data/ETL Developer

Company: Guidehouse
Location: Jefferson City
Posted on: September 16, 2023

Job Description:

**Job Family** **:** Software Development & Support (Digital) **Travel Required** **:** Up to 10% **Clearance Required** **:** Ability to Obtain Public Trust **What You Will Do:** Are you passionate about data and its transformative power? Do you have a deep understanding of Azure's data extract transform load (ETL) capabilities and a vision for leveraging data to drive business insights? If so, we have an exciting opportunity for you! Join our dynamic team as an Azure Data ETL Engineer and be at the forefront of our data-driven digital transformation journey, harnessing the power of Azure to extract, transform, and load data for meaningful analysis and decision-making. + Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements. + Administer, maintain, develop and recommend policies and procedures for ensuring the performance, availability, security and integrity of the companys databases and systems. + Identify, design and implement ETL solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis. + Architect solutions to help implement the physical data model for the development and/or production environments. + Perform regular deployments, scheduled maintenance and housekeeping. + Work with business and analysts and solution architects to identify, design and implement custom user interface programs for data management and extraction purposes. + Manage, monitor and administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability. + Manage job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations. + Collaborate with cross-functional teams to understand data requirements and design scalable and efficient ETL processes using Azure services. + Extract data from various sources, transform it into a usable format, and load it into Azure data storage solutions such as Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics. + Develop and maintain data pipelines using Azure Data Factory and other relevant Azure technologies. + Implement data quality checks, data validation, and data cleansing techniques to ensure accuracy and reliability of the data. + Optimize ETL processes for performance and scalability, leveraging Azure services such as Azure Data Factory Mapping Data Flows, Azure Data Lake Analytics, or Azure Synapse Pipelines. + Collaborate with data analysts and data scientists to understand their data needs and provide them with clean, reliable, and well-structured data sets for analysis and modeling. **What You Will Need:** + Bachelors degree or equivalent combination of education and professional work experience + At least 8 years of relevant experience + Proven experience being accountable for the data /analytics architecture solutions for a given business area how all the components, subsystems, platforms, and integrations fit together to meet the business needs and how the solution fits in with the greater enterprise context. Technologies include Azure SQL, Cosmos DB, Azure Synapse, Power BI. + Good knowledge of Cluster Architecture, Logical & Physical schema, flex tables etc. + Ability to Extract, Transform, Load, Manage and Troubleshoot daily transaction files from various processors + Ability to identify and validate data needs and/or information from external clients and internal staff + Interface across departments to understand the needs and objectives of the business + Ability to extract and prepare data for analysis across multiple platforms + Perform data quality analysis to ensure data integrity and accuracy of production data + Ability to proactively identify areas for improvement in data performance, quality, and processing + Sound understanding of Data Management best practices/methodologies, relational structures, dimensional data modeling (OLAP, OLTP, etc.), scale, structured query language (SQL) skills, query performance tuning, data warehouse and reporting techniques (including ETL techniques) + Strong experience in data extract transform load (ETL) processes using Azure services, such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics. + Proficiency in SQL and scripting languages such as Python or PowerShell for data manipulation and transformation. + Familiarity with data modeling concepts and best practices. + Solid understanding of data integration patterns and techniques. + Experience with data quality management and data governance principles. + Strong problem-solving skills and ability to work in a fast-paced, collaborative environment. + Excellent communication skills to effectively convey technical concepts to both technical and non-technical stakeholders. **What Would Be Nice To Have** **:** + Experience with DevOps Pipeline, GIT, JIRA is preferred + Masters Degree is preferred + Azure architecture and/or developer certification is preferred + Platform modernization experience in taking legacy applications to distributed solutions (SaaS, PaaS) is preferred + Experience migrating Mainframe and monolithic systems to the Azure Cloud preferred The annual salary range for this position is $130,200.00-$195,300.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs. **What We Offer:** Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Benefits include: + Medical, Rx, Dental & Vision Insurance + Personal and Family Sick Time & Company Paid Holidays + Parental Leave + 401(k) Retirement Plan + Group Term Life and Travel Assistance + Voluntary Life and AD&D Insurance + Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts + Transit and Parking Commuter Benefits + Short-Term & Long-Term Disability + Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities + Employee Referral Program + Corporate Sponsored Events & Community Outreach + Care.com annual membership + Employee Assistance Program + Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.) + Position may be eligible for a discretionary variable incentive bonus **About Guidehouse** Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. _Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee._

Keywords: Guidehouse, Jefferson City , Senior Azure Data/ETL Developer, IT / Software / Systems , Jefferson City, Missouri