Data Operations Engineer Junior Apply
Job Title: Data Operations Engineer-Junior
Location: Dallas, TX
Location: Dallas, TX
Job Overview
ETL & Azure exp required.
The Data Operations Engineer shall apply specialized knowledge in writing high-performance SQL
queries and data engineering solutions that moves, cleans, and loads data to differing systems. The
person will interact with our clients and differing roles within IT to gain understanding of the business
environment, technical context, and strategic direction. This person will also be responsible for
generating documentation as needed; conform to security and quality standards; and stay current on
emerging trends. Teams supported include: Application Engineering, Data Platform Engineering, Data
Engineering, Decision Science, and Business Analytics
A successful candidate for this position, you must:
Be comfortable with researching data questions, identify root causes, and interact closely with business users and technical resources on various data related decisions
Proactively identify and assist in solving recurring data quality or data availability issues.
Have experience in monitoring, troubleshooting, and resolving ETL issues.
Be able to develop high performance data queries, stored procedures and/or functional code for data related ad-hoc reporting and/or ETL batch triage reasons.
Understand how to profile code, queries, programming objects and optimize performance
Aspire to be efficient, thorough, and proactive
The Data Operations Engineer shall apply specialized knowledge in writing high-performance SQL
queries and data engineering solutions that moves, cleans, and loads data to differing systems. The
person will interact with our clients and differing roles within IT to gain understanding of the business
environment, technical context, and strategic direction. This person will also be responsible for
generating documentation as needed; conform to security and quality standards; and stay current on
emerging trends. Teams supported include: Application Engineering, Data Platform Engineering, Data
Engineering, Decision Science, and Business Analytics
A successful candidate for this position, you must:
Be comfortable with researching data questions, identify root causes, and interact closely with business users and technical resources on various data related decisions
Proactively identify and assist in solving recurring data quality or data availability issues.
Have experience in monitoring, troubleshooting, and resolving ETL issues.
Be able to develop high performance data queries, stored procedures and/or functional code for data related ad-hoc reporting and/or ETL batch triage reasons.
Understand how to profile code, queries, programming objects and optimize performance
Aspire to be efficient, thorough, and proactive
Responsibilities and Duties
Monitors, supports, triages data pipelines and ETL tasks that ingest, move, transform, and integrate data in a secure and performant manner.
Prepares necessary SQL scripts to perform data manipulation in key systems to address data related application and reporting needs.
Explores new technologies and data processing methods to increase efficiency, performance, and flexibility to proactively address recurring data related issues.
Document requirements and translate into proper system requirements specifications using high-maturity methods, processes, and tools.
Designs, prepares, and executes unit tests.
Participates in cross-functional teams.
Represents team to clients.
Demonstrates technical leadership and exerts influence outside of immediate team.
Develops innovative team solutions to complex problems.
Contributes to strategic direction for teams.
Applies in-depth or broad technical knowledge to provide maintenance solutions across one or more technology areas (e.g. SSIS, Azure ADF).
Integrates technical expertise and business understanding to create superior solutions for clients.
Consults with team members and other organizations, clients and vendors on complex issues.
Work on Special projects as requested
Performs other duties as assigned
Qualifications
Bachelor's degree in IT preferred. Equivalent combination of education and experience may be substituted in lieu of degree.
2 to 4 years of Microsoft SSIS package development experience including experience with Microsoft Visual Studio
1+ years of experience working with enterprise data warehouses
5+ years of experience in SQL and be able to write complex logic using SQL as part of ETL, and use SQL effectively to perform complex data analysis and discovery
1+ years of experience building reports with SSRS.
Exposure to Azure and Azure Data Factory
Exposure to an Enterprise Data Lake
Demonstrate strong organization skills and detail-oriented
Experience with CMD shell and PowerShell
Experience with large-scale, complex data environments
Ability to self-motivate and meet deadlines
Intense desire to learn
Ability to express complex technical concepts effectively, both verbally and in writing
Ability to multi-task in a fast-paced, changing environment
Ability to maintain confidentiality
Bachelor's degree in IT preferred. Equivalent combination of education and experience may be substituted in lieu of degree.
2 to 4 years of Microsoft SSIS package development experience including experience with Microsoft Visual Studio
1+ years of experience working with enterprise data warehouses
5+ years of experience in SQL and be able to write complex logic using SQL as part of ETL, and use SQL effectively to perform complex data analysis and discovery
1+ years of experience building reports with SSRS.
Exposure to Azure and Azure Data Factory
Exposure to an Enterprise Data Lake
Demonstrate strong organization skills and detail-oriented
Experience with CMD shell and PowerShell
Experience with large-scale, complex data environments
Ability to self-motivate and meet deadlines
Intense desire to learn
Ability to express complex technical concepts effectively, both verbally and in writing
Ability to multi-task in a fast-paced, changing environment
Ability to maintain confidentiality
