Job:Data EngineerLocation: 100%RemoteDuration: Direct HireSalary Range: $110 - $125K base** We are unable to Sponsor at this time***Apex Systems is seeking a highly experienced Data Engineer for an exciting full-time remote job for a company located in Ohio. As a Data Engineer, you will join a brand-new Digital team tasked with leading an enterprise-wide Digital transformation. You will work on an Agile team that is digitally enabling the company by building data pipelines that drive analytic solutions. These solutions will generate insights from the connected data, enabling the organization to advance the data-driven decision-making capabilities of the enterprise. This role requires a deep understanding of data architecture, data engineering, data analysis, reporting, and a basic understanding of data science techniques and workflows. The ideal candidate is a skilled data and software engineer with experience creating data products supporting analytic solutions.Required:5+ years of experience with the following:
- Experience delivering large scale analytics projects - leading requirements gathering, design and architecting complex solutions such as, cloud migration, integration of data from 6 or more various source systems involving data collection and storage systems (structured and unstructured data)
- Dimensional modeling (Kimball, etc.) exposure
- Oracle SQL
- Experience with ETL tools such as Informatica, Azure Data Factory
- Data Cloud and/or data lake experience
- Conceptualizingdata and creating concepts
- Strong communication
Job Duties:
- Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals.
- Design and architect different data sets going into the data lake and then into subsequent warehouses and data marts.
- ETL work for moving data from one place to another (Informatica primarily is ETL tool they use for data governance, data replication, data capture, datacenter, etc.)
- Working with on-prem data lake in MS-SQL (relational) and will be working to design and architect different data sets going into the data lake and then into subsequent warehouses and data marts
- Solve complex data problems to deliver insights that help the organizations business to achieve their goals
- Create data products for analytics and data scientist team members to improve their productivity
- Advise, consult, mentor, and coach other data and analytic professionals on data standards and practices
- Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions
- Lead the evaluation, implementation, and deployment of emerging tools and processes for analytic data engineering to improve the organizations productivity as a team
- Partner with business analysts and solutions architects to develop technical architectures for strategic enterprise projects and initiatives.
Highly Desired:
- Experience in designing and/or developing analytics applications using tools such as Power BI, QlikView, SAS, RapidMiner, or other comparable products
- Experienced in Agile/Scrum development with DevOps methodologies geared toward rapid prototyping and piloting of cloud solutions
- Experience with DataBricks OR Snowflake
- Python/Pandas/PySpark
Education:
- Bachelor's degree in Computer Science is must have with 5years related experience.
EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-###-####.Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.