Data Engineer

*Data Engineer*

*Job Description:*

Capitol Tech Solutions (CTS) is a leading tech consulting company that partners with businesses across various industries to provide innovative solutions and drive digital transformation. Our team of skilled professionals is committed to delivering top-notch consulting services that help our clients stay ahead of the competition and achieve their business objectives. As we continue to expand our reach, we are seeking a talented and motivated Data Engineer to join our dynamic team.

*Primary Responsibilities:*

The Data Engineer will be responsible for designing, building, and maintaining data pipelines and data warehousing solutions that support the business with data-driven decision-making. The successful candidate will have a strong background in data engineering, data modeling, and database administration, and be able to work collaboratively with business partners and other IT teams to ensure data accuracy, availability, and security.

* Design, build, and maintain data pipelines and ETL processes that collect, transform, and load data from multiple sources into our data warehouse
* Develop and maintain data models, database schemas, and other data structures that support data analytics and reporting
* Ensure data quality, accuracy, and consistency across the enterprise data landscape
* Collaborate with business partners and other IT teams to understand data requirements and ensure data solutions meet business needs
* Design and implement data security and access controls that comply with industry standards and regulatory requirements
* Monitor and troubleshoot data pipelines and data warehousing solutions to ensure optimal performance and reliability
* Deliver interactive data visualizations and dashboards that translate complex datasets into actionable insights
* Stay current with industry trends and best practices in data engineering, data modeling, and database administration
* Work closely with cross-functional teams to deliver successful projects.
* Collaborate with software developers to integrate data solutions with .NET applications and support related development tasks, as experience allows.

*Qualifications:*

* Bachelor's degree in Computer Science, Information Systems, or related field
* 7+ years of experience in data engineering, data modeling, and database administration
* Strong understanding of ETL processes, data warehousing, and database architecture
* Experience with cloud-based data technologies such as Snowflake, Databricks, AWS, Azure, or Google Cloud
* Proficient in SQL and programming languages such as Python, Java, or Scala
* Experience with .NET is preferred but not required.
* Familiarity with data visualization and reporting tools such as Power BI, Tableau, or QlikView
* Excellent communication and collaboration skills, with the ability to explain technical problems and issues to non-technical audiences clearly.
* Sharp analytical and problem-solving skills, with a proactive approach to troubleshooting and resolving data issues.
* Ability to work independently and manage multiple priorities in a fast-paced environment
* Demonstrated ability to learn quickly and apply new knowledge effectively.

Pay: $90,000.00 - $122,573.13 per year

Benefits:
* 401(k)
* 401(k) matching
* Dental insurance
* Health insurance
* Life insurance
* Paid time off
* Vision insurance

Work Location: In person