Data Integration Specialist
Arthur Grand Technologies Inc
Location
Indiana | United States
Job description
Data Integration Specialist Location Hybrid remote in Woodlawn, MD : Company Description
Arthur Grand (AG) is an IT services firm specializing in Digital Transformation initiatives for Federal, Commercial, State & local customers. Since 2012, AG has (been) successfully supporting and delivering IT services to our customers in the areas of enterprise modernization and transformation with a core focus on emerging technologies including Cloud Solutions (AWS, Azure), Agile Development and Custom Programming, Full Stack Development, DevOps, DevSecOps, & CI/CD, Web & Mobile APP Development, Data Visualization and Data Warehousing, Financial/ERP System Implementation, Infrastructure Management. Arthur Grand's culture of (delivery excellence) or excellent delivery, combined with a commitment to bring the best talent to provide services, has earned our company an unparalleled reputation for delivering transformative results.
Position Title: Data Integration Specialist
Location: Woodlawn, MD (Hybrid - 2 days onsite, 3 days remote)
Long Term contract
Key Required Skills: Worked with advanced technical principals, theories, and concepts; well versed in technical products; able to work on complex technical problems and providing innovative solutions; and can work with highly experienced and technical resources.
Position Description:
- Demonstrates ability to communicate technical concepts to non-technical audiences both in written and verbal form.
- Assembles large, complex data sets to meet business requirements.
- Works in tandem with Data Architects to align on data architecture requirements provided by the latter.
- Creates and maintains optimal data pipeline architecture.
- Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery.
- Implements big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.
- Supports development of Data Dictionaries and Data Taxonomy for product solutions.
- Demonstrates strong understanding with coding and programming concepts to build data pipelines (e.g., data transformation, data quality, data integration, etc.).
- Builds data models with Data Architect and develops data pipelines to store data in defined data models and structures.
- Demonstrates strong understanding of data integration techniques and tools (e.g., Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT)) tools and database architecture.
- Demonstrates strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).
- Identifies ways to improve data reliability, efficiency, and quality of data management.
- Conducts ad-hoc data retrieval for business reports and dashboards.
- Assesses the integrity of data from multiple sources.
- Manages database configuration including installing and upgrading software and maintaining relevant documentation.
- Monitors database activity and resource usage.
- Performs peer review for another Data Engineer's work.
- Assists with development, building, monitoring, maintaining, performance tuning, troubleshooting, and capacity estimation.
- Sources data from the operational systems.
- Prepares the database-loadable file(s) for the Data Warehouse.
- Manages deployment of the data acquisition tool(s).
- Monitors and maintains Data Warehouse/ELT.
- Monitors, reports, and resolves data quality.
- Works closely with all involved parties to ensure system stability and longevity.
- Supports and maintains Business Intelligence functionality.
- Evaluates, understands, and implements patches to the Data Warehouse environment.
- Loads best practices and designs multidimensional schemas.
- Attend all customer technical discussions/design/development meetings and provide technical inputs to further enhance the code quality/process.
- Provide guidance/support to other junior/mid-level developers.
- Impact functional strategy by developing new solutions, processes, standards, or operational plan.
- All other duties as assigned or directed.
Skills Requirements:
(Basic Qualifications) This experience is the foundation a candidate needs to be successful in this position:
- Bachelor's degree in computer science, IT, or related field/experience
- Must be able to obtain and maintain a Public Trust. Contract requirement.
- 7 years of experience with Data Engineering, working with large-scale data processing and ETL pipelines.
- 5 years of hands-on experience with data modeling, architecture, and management
- 5 years of experience with Relational Database Systems, Data Design, RDBMS Concepts, ETL
- 5 years of experience working with data in cloud environments such as AWS (preferred), Azure, GCP
- 3 years of experience in T-SQL, SQL, ELT/ETL performance tuning.
Required Skills These skills will help you succeed in this position:
- Programming experience in Snowflake, Hadoop, or other Data Warehouse technologies; Snowflake preferred.
- Experience in Microsoft SQL Server 2008R2 or newer.
- Experience with SSIS or equivalent ETL tool.
- Experience in SQL/Stored Procedure development.
Desired Skills Showcase your knowledge of modern development through the following experience or skills :
- Understanding of semi-structured / unstructured data using JSON, AVRO, Parquet, CSV, etc.
- Experience with complex multi-server environments and high availability environments.
- Experience using Azure Data Factory, Five Tran, Spark or other similar data integration tools
- Experience with system monitoring, log management, and error notification.
- Fundamental network and IT infrastructure knowledge.
- Highly motivated; able to work independently, multi-task, respond to changing priorities, and initiative to own specific tasks.
- Strong problem determination, troubleshooting, and resolution skills.
- Excellent written and oral communication skills & customer service skills.
- Ability to work analytically to solve both tactical and strategic problems.
Education:
- Bachelor's degree in computer science, IT, or related field and 7+ years of experience
- Must be able to obtain and maintain a Public Trust.
Additional Information All your information will be kept confidential according to EEO guidelines.
Job tags
Salary