Key skills
ApacheAWSAzureCloudDynamoDBETLGraphQLMongoDBMS SQL ServerOracleRedisSQLSSISTFSBIBusiness IntelligencePower BIGlueSQL ServerRepositoryCommunication
About this role
Role Overview
- Meet and coordinate with internal and external stakeholders to establish project scope, system goals, and requirements
- Help translate business requirements into technical specifications for data consumption and use
- Provide guidance on appropriate data platform(s) (repository, database, etc.) to meet requirements
- Accurately map data attributes between different domain models
- Develop, analyze, prioritize, and organize requirement specifications, data mapping, diagrams, data models and flowcharts for developers and testers to follow
- Help deploy and troubleshoot application data pipelines across various architectural environments that will vary by client from legacy to modern including application servers, queues, API gateways, databases, etc. or cloud-based equivalents
Requirements
- Typically has 5+ years of experience with varied technical experience in designing/developing data pipelines and data stores
- Demonstrated experience designing data architecture(s) for Business Intelligence/Analytical usage
- Understanding of data modeling and data mapping
- Experience with Data Warehouse and Data Mart
- Experience with TFS, Microsoft SQL Server, Microsoft SSIS, Power BI
- Extensive experience with SQL
- Extensive experience with relational and non-relational database technologies (Oracle, MS SQL Server, GraphQL, DynamoDB, MongoDB, PostgresSQL, Redis, ElastiCache, etc)
- Experience in ETL (AWS Glue, Azure DataFactory, Apache NiFi, etc)
- Experience with a variety of data systems and performance tuning approaches
- Knowledge of a variety of architectural principles like hub and spoke, bus, event driven software architectures, etc
- Working knowledge of Data Science technology stacks
- Working knowledge of BI data analytical products
- Excellent verbal and written communication skills
- Ability to present technical solutions to both technical and non-technical audiences
- Strong ability to review existing codebases/processes and refactor for improvement vs starting over
- Strong problem solver
- Professional presence
- Bachelor’s Degree or equivalent experience
Tech Stack
- Apache
- AWS
- Azure
- Cloud
- DynamoDB
- ETL
- GraphQL
- MongoDB
- MS SQL Server
- Oracle
- Redis
- SQL
- SSIS
- TFS
Benefits
- Robust healthcare and benefits including Medical, Dental, vision, Disability coverage, and various other benefit options
- Flexible Spending Accounts (Medical, Transit, and Dependent Care)
- Employer Paid Life Insurance and AD&D Coverages
- Health Savings account paired with our low-cost High Deductible Medical Plan
- 401(k) Safe Harbor Retirement plan with employer match with immediately vest