Data Architect

Northstrat is seeking experienced Data Architects to join our dynamic team. The ideal candidate will possess a deep understanding of data architecture principles, translating business requirements into technical specifications, and designing an enterprise data management framework. This role involves visualizing and implementing processes for data planning, specification, creation, maintenance, use, archiving, retrieval, control, and purging, particularly in support of data and digital transformations.

Key Responsibilities:

• Translate business requirements into technology requirements and define data standards and principles.
• Visualize and design an organization’s enterprise data management framework.
• Plan, specify, enable, create, acquire, maintain, use, archive, retrieve, control, and purge data.
• Collaborate respectfully with teammates and prioritize user missions.
• Operate within a culture of teamwork, sharing information, and prioritizing team success over individual success.
• Communicate effectively to solve problems and achieve mission goals.

Requirements

• Minimum of 5 years of experience in data architecture, design, and development of enterprise data warehouse components.
• Extensive experience with star schemas, Type I and Type II dimensions, facts to dimensions matrices.
• Proven expertise in large enterprise data warehousing, reporting, and Business Intelligence (BI) projects.
• Strong knowledge of dimensional modeling concepts.
• Experience in building conceptual, logical, and physical data models.
• Proven ability to develop and maintain a metadata repository.
• Expertise in at least one major RDBMS platform (DB2, PostgreSQL, or SQL Server).
• Excellent oral and written communication skills.
• Strong people skills to identify requirements and deliver results.

Desired Qualifications:

• Experience in a multi-contractor environment with daily interactions with customers and peers from other companies.
• Ability to exhibit a high degree of professionalism, flexibility, and tolerance to change.
• Experience in delivering periodic status presentations to customers and program management.
• Understanding of the operational environments for developed technologies.
• Experience using data modeling tools, preferably ERWin and/or TOAD Data Modeler.
• Understanding of ETL tools, preferably Informatica.
• Prior work experience with the Federal Bureau of Investigation.

Benefits

Individual Benefits Account (IBA)

In order to attract and retain the highest quality staff, Northstrat provides a unique and versatile benefits package, the Individual Benefit Account (IBA), which places the power of choice in the hands of our greatest asset – the employee.

The purpose of the IBA is to provide attractive benefits to all full-time employees of Northstrat on a flexible basis that enables each covered employee to select a package that best suits his or her needs. Whether those needs are paid time off, medical expenses, prescription drug expenses, cash disbursement, or a combination of any of these, the IBA provides flexibility to help you meet your specific goals. The IBA can be used for such things as:

• Medical and Vision Insurance through United Health Care; Dental insurance through Delta Dental
• 100% Medical Reimbursement
• Time Off With Pay
• Profit Sharing Plan
• 401k
• Educational Benefits
• Additional Income

IBA Benefits accrue each month in the amount equivalent to 50% of the employee’s monthly compensation rate. That is, the effective dollar amount of this accrual is in addition to an employee’s salary.

Profit Sharing Plan (PSP)

The PSP is a qualified retirement plan that Northstrat funds semi-annually on the employee’s behalf through the IBA in the amount equivalent to 25% (up to the IRS contribution limit) of the employee’s compensation. That is, of the 50% accrual in the IBA, half of the amount accrued is applied to the PSP.

Stock Options

Because Northstrat is an employee-owned company, all new employees are offered stock options. Employees have the opportunity to receive additional stock options based on accomplishment of individual performance goals. Stock owners elect the Board of Directors and are directly impacted by the success of the company.

Flex Time

Northstrat does not mandate specific working hours. Although project requirements may dictate schedules, a Northstrat employee is only required to work an average of 8 hours per weekday over the course of a month. For example: John worked 12 hours on June 1st to meet a project deadline. On June 15th, John only worked 4 hours because he left early for a long weekend. John’s IBA was not debited for time off because flex time allowed him to carry over those 4 hours from June 1st.

Northstrat is an Equal Opportunity Employer – All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other characteristics protected by law.