Data Analyst

RED CANYON TECHNOLOGIES LLC; Dayton (OH); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Comprehensive benefits package

Tuition reimbursement

Paid time off

Job summary

RED CANYON TECHNOLOGIES LLC is seeking a Data Analyst who will provide high-quality service in managing data portfolios. The role involves data quality management and supporting IT services through analytical techniques.

The ideal candidate will have at least 5 years of experience and a Bachelor's degree in Computer Science, along with proficiency in SQL and experience with ETL software. Benefits include comprehensive health coverage and retirement savings.

Qualifications

• 5+ years of experience as a Data Analyst.
• Proficient in SQL for data analysis and quality.
• Experience with ETL performance optimization.

Responsibilities

• Analyze operational activities for informed decision-making.
• Reverse engineer data models for metadata extraction.
• Develop ETL routines to curate data sets.

Skills

Data analysis

SQL

ETL software experience

Scripting languages

Data quality management

Agile methodologies

Education

Bachelor's degree in Computer Science

Tools

StreamSets

DataBricks

Jupyter Notebooks

Job description

The Data Analyst will work with a team to provide high-quality service to our customers in managing a portfolio of systems. This role is responsible for executing data management activities in data quality and data asset management.This position is a collaborative role that provides support for analysis and research into our data structures, attribution, maintenance, and models to ensure they align with the organization’s strategic data management direction. This position is also responsible for maintaining the visibility and integrity of the portfolio’s data asset inventory by identifying and closing any information gaps.The Data Analyst will work within an agile team to provide high-quality service to our customers by applying analytical techniques to determine solutions based on client requirements within an IT services/solutions scope. They will analyze and reverse-engineer business and technical artifacts, such as data models, data catalogs, design documentation, and interfaces, to capture, store, and maintain relevant metadata for the systems within the portfolio. This role may also be expected to develop and maintain data quality assessments and data profiles for the systems within the portfolio. As such, they will be expected to work closely with functional and technical data stewards to present their findings and provide recommendations to address any identified issues.*This position is contingent upon contract need.*Responsibilities:Analyze operational activities to obtain a quantitative, rational basis for decision making and resource allocationConceptually understand and convey to stakeholders and leadership complex topics related to data management, data governance, and data maturityWork with subject matter experts (SME) across organizations to collect and update business and technical metadataReverse engineer data models and other design or build artifacts to extract relevant business and technical metadata and load into a metadata repositoryReview submitted data to detect data quality problems and anomalies, and help the organization correct data: both current and historicalCollects and analyzes data and associated system artifacts for stakeholders to use in perfecting their business practicesPerforms analysis to determine how data might best be applied to benefit the stakeholdersDevelops ETL routines to load and curate disparate data setsOther duties as assignedQualifications:Years of Experience: 5+Education Level: Bachelor's degree in Computer Science or similar and 5+ years of experienceClearance Requirements: Must be able to obtain a Secret ClearanceExperience with ETL or data movement software such as StreamSets, DataBricks, Jupyter Notebooks, etc.Experience using SQL for data analysis, data quality, and data profiling activitiesExperience leading small 3-4 person teamsExperience in one or more scripting languagesExperience in ETL performance optimizationExperience working with large data sets in enterprise-level data warehousing/lake environmentsExperience creating data mapping documentation for databases, interfaces and applicationsExperience with Agile development methodologies and rolesQualifications considered a plus:Experience with AF Logistics systems and dataExperience with PythonExperience in requirements elicitationExperience in Information Management, including data design, data transformation, data governance or other major DAMA DMBOK or industry-recognized data management practiceExperience in working with and defining dataExcellent written and verbal communicationsLogical thinker; able to articulate thoughts both verbally and diagrammaticallyExperience in logical data modelling and data normalizationExperience interpreting data and analyzing results using statistical techniquesExperience with data collection systems and their strategiesAbout UsDiné Development Corporation (DDC) is a Navajo Nation owned family of companies that provides government agencies and commercial organizations with high-quality IT, professional, environmental, and research and development services. DDC is dedicated to empowering the Navajo Nation and communities we serve.BenefitsEligible full-time employees receive a comprehensive benefits package, including medical, dental, vision, life and disability coverage, retirement savings with company match, paid time off, voluntary supplemental benefits, and access to an employee assistance program. The package also includes educational assistance, with tuition reimbursement.EEO StatementThis contractor and subcontractor shall abide by the requirements of 41 CFR 60-1.4(a), 60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities, and prohibit discrimination against all individuals based on their race, color, religion, sex, sexual orientation, gender identity, national origin, or for inquiring about, discussing, or disclosing information about compensation, or any other basis prohibited by law. We participate in E-Verify.DDC is committed to providing equal employment opportunities to all applicants and employees. If you require a reasonable accommodation to participate in the application or interview process, please contact Recruiting for assistance [e-mail]