- Columbus, OH, USA
CapTech is a team of master builders, creators, and problem solvers who help clients grow efficient, successful businesses. We unite diverse skills and perspectives to transform how data, systems, and ingenuity enable each client to advance what’s possible in a changing world.
As perceptive partners, our U.S-based consultants find inspiration in the unknown and enjoy getting our hands dirty solving our clients’ myriad of challenges. Across industries and business goals, we fuse technical depth and analytical prowess with creative savvy to move clients forward. This drive helps each organization use technology, management, and insight to turn ideas into action. Together, we create outcomes that exceed the expected — which is one of the reasons we’ve been on the Inc. 500/5000 list for over a decade.
The Data Engineer, Analytics role falls into the Data Management & Business Intelligence practice area at CapTech, through which our consultants provide a broad spectrum of services to help our clients define and implement a strategy to deliver lasting and mission-critical information capabilities. Our Data Integration consultants bridge the gap between the business and IT side of companies. By partnering with clients to fully understand both their business philosophy and IT strategy, CapTech consultants maintain the vision that data integration should be built to help the organization make better decisions by providing the right data at the right time.
Specific responsibilities for the Data Engineer, Analytics position include:
- Design, develop, document, and test advanced data systems that bring together data from disparate sources, making it available to data scientists, analysts, and other users using scripting and/or programming languages (Python, Java, C, etc)
- Evaluate structured and unstructured datasets utilizing statistics, data mining, and predictive analytics to gain additional business insights
- Design, develop, and implement data processing pipelines at scale
- Present programming documentation and design to team members and convey complex information in a clear and concise manner.
- Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient programming processes.
- Write and refine code to ensure performance and reliability of data extraction and processing.
- Communicate with all levels of stakeholders as appropriate, including executives, data modelers, application developers, business users, and customers
- Participate in requirements gathering sessions with business and technical staff to distill technical requirements from business requests.
- Partner with clients to fully understand business philosophy and IT Strategy; recommend process improvements to increase efficiency and reliability in ETL development.
- Collaborate with Quality Assurance resources to debug code and ensure the timely delivery of products.
- Some of our technologies might include: HDFS, Cassandra, Spark, Java, Scala, Informatica, SQL Server, Oracle, Ab Initio, Kafka.
Specific qualifications for the Data Engineer, Analytics position include:
- Bachelor's degree in Computer Science, Software Engineering, MIS or equivalent combination of education and experience
- Minimum of 3 years experience designing, developing, and testing software aligned with defined requirements
- Development experience building ETL graphs using the Ab Initio GDE, EME and Co-Operating system
- Strong SQL development skills
- Development experience with at least two different programming languages (Python, Java, C, etc.)
- Development experience with Unix tools and shell scripts
- Development experience with at least two different database platforms (Teradata, Oracle, MySQL, MS SQL, etc.)
- Experience tuning SQL queries to ensure performance and reliability
- Software engineering best-practices, including version control (Git, TFS, JIRA, etc.) and test driven development
- Exposure to Business Intelligence tools such as Business Objects, Informatica, SSRS, Cognos, MicroStrategy, Tableau, QlikView, SpotFire, etc.
We offer challenging and impactful jobs with professional career paths. All CapTechers can keep their hands-on technology no matter what position they hold. Our employees find their work exciting and rewarding in a culture filled with opportunities to have fun along the way.
At CapTech we offer a competitive and comprehensive benefits package including, but not limited to:
- Competitive salary with performance-based bonus opportunities
- Single and Family Health Insurance plans, including Dental coverage
- Short-Term and Long-Term disability
- Matching 401(k)
- Competitive Paid Time Off
- Training and Certification opportunities eligible for expense reimbursement
- Team building and social activities
- Mentor program to help you develop your career
CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion and fairness — each foundational to our core values. We strive to create a diverse environment where each employee is encouraged to bring their unique ideas, backgrounds and experiences to the workplace.
Candidates must be eligible to work in the U.S. for any employer directly (we are not open to contract or “corp to corp” agreements). At this time, CapTech cannot transfer nor sponsor a work visa for this position. Applicants must be authorized to work directly for any employer in the United States without visa sponsorship.
CapTech is a Drug-Free work place.
Candidates must have the ability to work at CapTech’s client locations.
All positions include the possibility of travel.
CapTech has not contracted/does not contract with any outside vendors in its recruitment process. If you are interested in this position, please apply to CapTech directly.