Data Architect
Data Architect - Dallas
About the team:
Capco's Data Team helps our clients transform every aspect of their business. We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client's business goals. As digital technologies advance and regulations tighten, today's consumers - and, therefore, today's businesses - are becoming more aware of the importance of good quality data. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting.
About the Job:
As a member of our Data Team, you will work across Capco's different domains and solution offerings to help break down large problems, develop approaches and solutions. As a Data Platforms (Architect), you will work with the industry's leading data platforms to create data-driven, strategic solutions which will help drive transformation for our clients.
What You'll Get to Do:
- Work on hard problems with smart people
- Be highly motivated, result-oriented, and take pride in being a problem solver
- Work with new technology, focus on using the right tool for the job, rather than any sticky preference for a tool or technology
- Learn and share knowledge across our engineering teams, so we can continue to iterate and improve
- Write reusable, testable, and efficient code
- Design and implement of low-latency, high-availability, and performant data platform solutions
- Collaborate and work on integration of data storage solutions
- Focus on performance tuning, improvement, balancing, usability and automation
What You'll Bring with You:
- 3+ years demonstrated experience helping organizations design or implement effective Data Management and/or Analytics programs in the cloud or on premises
- Success working in one of several Data Engineering/Management technology areas, including but not limited to:
- Experience in design or development of enterprise data solutions, applications, and integrations on a data platform
- Design and develop both physical and logical data models along with define metadata standards for the DW
- Develop ETL Data Pipeline and Data Model solutions for integrating new data sets into a data platform from different sources.
- In-depth understanding of database management systems and advantages & disadvantages of different types of systems (OLAP, OLTP, etc.).
- Strong experience with Data warehousing methodologies and modelling techniques
- Perform data mapping activities between source systems and DW
- Hands-on experience in Cloud technologies such as:
- Azure - Azure Synapse Analytics, Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory and Azure Analysis Services
- AWS - S3, Glacier, EC2, Lambda, SQS, Redshift, DMS
- Leads analysis, architecture, design, and development of DWBI solutions
- Experience with on-premise to cloud data platform migrations
- Experience working directly with business users and solving business questions with data
- Experience using Python scripting to read & load data from sources and perform data manipulation
- Experience in working with Batch and API Stream data integrations
- 2+ years of experience in DevOps and CI/CD deployments
- Experience with reporting and analytics tools are a plus (Tableau, QuickSight, Cognos, Power BI etc.)
- Experience with ELT concepts & tools such as Talend, Informatica, Matillion is a plus
- Experience in Financial Services and consulting is a plus
Why Capco?
You will join a company that supports and encourages an entrepreneurial outlook and independent thinking. Capco is not about organizational charts and layers - we operate with little hierarchy because we want all employees to feel that Capco is their firm.
We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees.
Ready to Take the Next Step?
If this sounds like you, we would love to hear from you. This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.