What are the responsibilities and job description for the Data Analyst (ETL, Agile, Python) position at IBSS?
Job Title: Data Analyst (ETL, Agile, Python)
Location: Dayton, OH
Clearance Required: Ability to obtain an active DoD Secret Clearance
Description:
The Data Analyst will work with a team to provide high-quality service to our customer in managing the logistics IT portfolio of systems. This role is responsible for the execution of data management activities within the areas of data quality and data asset management.
This position is a collaborative role providing support for analysis and research into our data structures, attribution, maintenance, and models to ensure they are compliant 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 information gaps that may exist.
The Data Analyst will work within an agile team to provide high-quality service to our customer by applying analysis techniques to determine solutions based on client requirements with an IT services/solutions-based 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 LogIT portfolio. As such, they will be expected to work closely with functional and technical data stewards to present their findings and provide recommendations for addressing issues which may be identified.
Key Responsibilities:
Since 1992, IBSS, a woman-owned small business, has provided transformational consulting services to the Federal defense, civilian, and commercial sectors. Our services include cybersecurity and enterprise information technology, environmental science and engineering (including oceans, coasts, climate, and weather), and professional management services.
Our approach is to serve our employees by investing in their growth and development. As a result, our employees bring greater capabilities and provide exceptional service to our clients. In addition to creating career development opportunities for our employees, IBSS is passionate about giving back to the community and serving the environment. We strive to leave something better behind for the next generation.
We measure our success by the positive impact we have on our employees, clients, partners, and the communities we serve. Our tagline, Powered by Excellence, is a recognition of the employees that make up IBSS and ensures we deliver results with quality, applying industry best practices and certifications.
IBSS offers a competitive benefits package that includes medical, dental, vision, and prescription drug coverage with a company-paid deductible, paid time off, federal holidays, a matching 401K plan, tuition/professional development reimbursement, and Flex-Spending (FSA)/Dependent Care Account (DCA) options.
IBSS is an affirmative action and equal opportunity employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Click https://www.eeoc.gov/poster to see that the EEO is the law. Please direct any inquiries to the HR Department email at HR@ibsscorp.com.
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to the Talent Acquisition department at Recruiting@ibsscorp.com
Location: Dayton, OH
Clearance Required: Ability to obtain an active DoD Secret Clearance
Description:
The Data Analyst will work with a team to provide high-quality service to our customer in managing the logistics IT portfolio of systems. This role is responsible for the execution of data management activities within the areas of data quality and data asset management.
This position is a collaborative role providing support for analysis and research into our data structures, attribution, maintenance, and models to ensure they are compliant 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 information gaps that may exist.
The Data Analyst will work within an agile team to provide high-quality service to our customer by applying analysis techniques to determine solutions based on client requirements with an IT services/solutions-based 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 LogIT portfolio. As such, they will be expected to work closely with functional and technical data stewards to present their findings and provide recommendations for addressing issues which may be identified.
Key Responsibilities:
- Analyze operational activities to obtain a quantitative, rational basis for decision making and resource allocation
- Conceptually understand and convey to stakeholders and leadership complex topics related to data management, data governance, and data maturity
- Work with subject matter experts (SME) across organizations to collect and update business and technical metadata
- Reverse engineer data models and other design or build artifacts to extract relevant business and technical metadata and load into a metadata repository
- Review submitted data to detect data quality problems and anomalies and help organization correct data: both current and historical
- Collects and analyzes data and associated system artifacts for stakeholders to use in perfecting their business practices
- Performs analysis to determine how data might best be applied to profit the stakeholders
- Develops ETL routines to load and curate disparate data sets
- Other duties as assigned
- Ability to obtain an active DoD Secret Clearance
- Bachelor's degree in Computer Science or similar and 5 years of experience
- Experience with ETL or data movement software such as StreamSets, DataBricks, Jupyter Notebooks, etc.
- Experience using SQL for data analysis, data quality, and data profiling activities.
- Experience in one or more scripting languages
- Experience in ETL performance optimization
- Experience working with large data sets in enterprise-level data warehousing/lake environments
- Experience creating data mapping documentation for databases, interfaces and applications
- Experience with Agile development methodologies and roles
- Experience with AF Logistics systems and data
- Experience with Python
- Experience in requirements elicitation
- Experience in Information Management including data design, data transformation, data governance or other major DAMA DMBOK or industry recognized data management practice
- Experience in working with and defining data
- Excellent written and verbal communications
- Logical thinker; able to articulate thoughts both verbally and diagrammatically
- Experience in logical data modelling and data normalization
- Experience interpreting data and analyzing results using statistical techniques
- Experience with data collection systems and their strategies
Since 1992, IBSS, a woman-owned small business, has provided transformational consulting services to the Federal defense, civilian, and commercial sectors. Our services include cybersecurity and enterprise information technology, environmental science and engineering (including oceans, coasts, climate, and weather), and professional management services.
Our approach is to serve our employees by investing in their growth and development. As a result, our employees bring greater capabilities and provide exceptional service to our clients. In addition to creating career development opportunities for our employees, IBSS is passionate about giving back to the community and serving the environment. We strive to leave something better behind for the next generation.
We measure our success by the positive impact we have on our employees, clients, partners, and the communities we serve. Our tagline, Powered by Excellence, is a recognition of the employees that make up IBSS and ensures we deliver results with quality, applying industry best practices and certifications.
IBSS offers a competitive benefits package that includes medical, dental, vision, and prescription drug coverage with a company-paid deductible, paid time off, federal holidays, a matching 401K plan, tuition/professional development reimbursement, and Flex-Spending (FSA)/Dependent Care Account (DCA) options.
IBSS is an affirmative action and equal opportunity employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Click https://www.eeoc.gov/poster to see that the EEO is the law. Please direct any inquiries to the HR Department email at HR@ibsscorp.com.
If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to the Talent Acquisition department at Recruiting@ibsscorp.com
