Data Engineer II

Job description


Data Engineer II – Enterprise Analytics is assisting in designing, developing, and deploying data-driven solutions as part of Enterprise Analytics data strategy and goals. Data Engineer II – Enterprise Analytics is responsible for creating reliable ETLs and scalable data pipelines to support Analytics and BI environment (including modeling and machine learning, visualizations, reports, cubes & applications, etc.). Data Engineer II – Enterprise Analytics participates in data modeling and development of data models and data marts by interpreting business logic required to turn complex ideas into a sustainable value add processes.

Essential Duties & Responsibilities

  • Collaborate with Enterprise Analytics BI Analysts and Data Scientists, and other business stakeholders to understand business problems and build/automate data structures ingested by analytics products (e.g.: reports, dashboards, cubes, etc.).
  • Create BI solutions, including dashboards (Power BI) and reports (SSRS, Excel, and Cognos).
  • Development of logic for KPIs requested by the business leadership.
  • Troubleshoot existing and create new ETLs, SSIS packages, SQL stored procedures and jobs.
  • Assist in Star and Snowflake modeling, creating dimensional models and ETL processes.
  • Write an efficient SQL code for use in data pipelines and data processing.
  • Drive data quality processes like data profiling, data cleansing, etc.
  • Develop best practices and approaches to support continuous process automation for data ingestion and data pipelines.
  • Use innovative problem solving and critical thinking approaches to troubleshoot challenging data obstacles.
  • Test, optimize, troubleshoot, and fine-tune queries for maximum efficiency.
  • Maintain existing and create new Microsoft Power Apps solutions (including but not limited to Power Apps, Power Automate, Power BI, Flows, etc.) according to business needs.
  • Perform QA and UAT processes to foster an agile development cycle.
  • Create documentation on table design, mapping out steps and underlying logic within data marts to facilitate data adoption with minimum guidance from the Enterprise Analytics management.
  • Identify areas of improvement not just in owned work, but also other areas of the business.
  • Mentor and train junior Data Engineers on best practices, query and ETL optimization techniques.
  • Create and maintain daily, weekly, monthly, quarterly reports and dashboards.
  • Consolidate fractured enterprise reporting into a standardized product for easy visualization and cross-departmental understanding.
  • Create reporting structures that accurately link cross-departmental data, which allows for on demand delivery of ad-hoc reports.
  • Safety is an essential function of this job.
  • Consistent and regular attendance is an essential function of this job.
  • Performs other related duties as assigned.

Additional Skills & Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, Engineering, Analytics, or related field is required.
  • Master’s degree in related discipline is preferred.
  • Must be able to obtain and maintain a Nevada Gaming Control Board registration and any other certification or license, as required by law or policy.
  • 2+ years of experience in building data pipelines and ETL processes is required.
  • 2+ years of experience creating visualizations and reports (Power BI, Tableau, MicroStrategy, Google Analytics) is required.
  • 2+ years of experience in writing advanced SQL, data mining and working with traditional relational databases (tables, views, window functions, scalar and aggregate functions, primary/foreign keys, indexes DML/DDL statements, joins and unions) and/or distributed systems (Hadoop, Big Query) is required.
  • 1+ years of experience with programming/scripting languages such as Python, R or Big Query is required.
  • Experience in either Microsoft Power Suite (Power Apps, Power Automate, Power BI, etc.), Microsoft Azure, Google Cloud Platform, or RPA tools is preferred.
  • Excellent understanding of data types, data structures and database systems and their specific use cases is required.
  • Strong understanding of data modeling principles including Dimensional modeling, and Data Normalization principles is required.
  • Extensive knowledge of Microsoft Excel (Excel formulas, data wrangling, VBA macros, graphs, and pivot tables) is required.
  • Excellent critical thinker and effective problem solver with creative solutions.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.