Data warehouse architect job description

• Recommend hardware solutions compatible with existing Data Center technologies
• Document data center physical hardware designs including: row, rack, bay, interconnections, power, network, storage, serial numbers, lifecycle, and supporting service information
• Create and document requisite data center configuration settings
• Deliver service catalog items for automatically provisioning data center infrastructure

Qualifications

• BS 8-10, MS 6-8, PhD 3-5
• Experience in Infrastructure/Datacenter engineering for both physical and virtual infrastructure hosting one or more Operating Systems: Windows, Linux, Solaris, UNIX, and/or AIX systems
• One or more engineering disciplines:
• Storage Engineering: multiple enterprise HPE Storage Area Networks (SAN)
• Network Engineering: Cisco network LAN/WAN, Software Defined Networking (SDN)
• Infrastructure/Cloud Engineering: VMware vCloud Enterprise Suite; hybrid cloud with multiple classified Government clouds.
• Must have a current DoD 8570.1-M IAT Level II certification (i.e., Security+ CE)
• Must possess an active TS/SCI clearance with SCI eligibility
• Professional-level Linux, VMware, Network, Storage, or Cloud certifications desired
• ITIL Foundations certification desired

Peraton Overview

Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our employees do the can't be done, solving the most daunting challenges facing our customers.

An Equal Opportunity Employer including Disability/Veteran.

For Colorado Residents Colorado Salary Minimum: $81,900
Colorado Salary Maximum: $198,600

The estimate displayed represents the typical salary range for this position, and is just one component of Peraton's total compensation package for employees. Other rewards may include annual bonuses, short- and long-term incentives, and program-specific awards. In addition, Peraton provides a variety of benefits to employees.

• A wicked-awesome benefits package (go ahead and compare)
• A Friday dress code every day of the week (dust off those jeans)
• Extreme crafting experiences (totally optional, but give it a try)
• Paid personal time off...like, a lot of it (see "work/life balance" above)
• Tuition assistance and 401(k) programs (company match, baby!)

Roles & Responsibilities

1. Exemplify Stampin' Up!'s core values: we care about people first, we act with courage, we better our best, and we own it.
2. Architect and implement conceptual, logical, and physical data models to support enterprise information strategies, the business intelligence agenda, as well as the company's self-service analytics approach.
3. Responsible for the integrity and quality of data and information stored and flowing between business applications, the enterprise data warehouse, datamarts, and business intelligence applications.
4. Work directly with project teams and solution owners to ensure that new and existing solutions adhere to established architecture standards and that there are controls in place to maintain a high level of data integrity.
5. Work with the business to ensure that data provided in reports, dashboards, and other analytical applications is used appropriately and governance rules are adhered to.
6. Prioritize and provide workable solutions to solve complex business problems using data and analytics.

Requirements

1. Bachelor's degree in computer science or related field or equivalent experience.
2. Expert level proficiency in SQL with the ability to perform complex data analysis with large volumes of data.
3. Strong knowledge of logical and physical data modeling concepts, hands-on development of attributes, facts, dimensions, and transformations.
4. Experience with the BI/DW lifecycle components including source data analysis, ETL, datamarts, reporting, dashboards, and analytics
5. Ability to work on a computer for prolonged periods of time.

Job Posted by ApplicantPro

Seeking an experienced Data Warehouse Architect to work with us to help us design the data ecosystem of the future. APA is using data to propel the organization forward improving customer value and experience. As a member of the Enterprise Data Management & Analytics team, the candidate will be responsible for participating in creating and evolving data technologies road map that defines data architectures and enables a solid enterprise data strategy at APA. The candidate will be responsible for setting best practices, standards and providing solution design support for executing solutions surrounding enterprise data (including high velocity/volume structured and unstructured data sets) and distributed platforms. The candidate will utilize in-depth knowledge and expert skills to drive enterprise optimization by introducing solutions to advance data architecture principles (i.e., data modeling, profiling, metadata management, data quality, and master data management, analytics & reporting, etc.). He/She will also translate business needs into data architectural solutions that meet performance, reliability and security expectations.
EDUCATION AND EXPERIENCE:


Bachelor's degree in computer science, information technology, software engineering, or a related field or equivalent experience. At least 6-8 years of relevant experience in the capacity of Data Architect, with extensive experience leading Information/data architecture methodologies, data warehousing principles and frameworks across an organization. Must be detail and process oriented and possess a collaborative working style and the ability to work both independently and in a team environment. Experience working in an Agile Development, AWS Cloud environment and Microsoft Azure a plus.


COMPUTER SKILLS REQUIRED:



Strong experience with Data Warehouse and databases schema designs with strong experience integrating Cloud CRM systems such as Microsoft Dynamic CRM or Salesforce CRM and in-depth understanding of database structure principles. Strong knowledge of data modeling warehousing and ETL methodology making use of cloud-based technologies such as AWS and Microsoft Stack (Microsoft SQL Server along with complementary technologies such as Microsoft Azure Data Factory, Data Lake, Streaming Data); experience creating conceptual, logical, physical data modeling with Data modeling tools such as Erwin data model. Strong experience in building modern data solutions in cloud technologies such as data lake including - Power BI Service and AWS/Microsoft Azure. Strong knowledge of Data Management including Structured and Unstructured Data Processing: data ingestion/transformation of various formats using Integration Tools such as Informatica, IDERA tools, Kafka, 360Science (MatchIT), CData tools, ADF, SSIS. Experience in data quality identification and implementing data governance principles in an enterprise data environment. Strong understanding of activities within primary discipline such as Master Data management (MDM), Customer Data Management (CDM), Metadata Management and Data Governance (DG). 5-6 years' experience with NoSQL, Visualization and reporting tools (Power BI, Amazon QuickInsights, SageMaker), data profiling analysis and transformation & experience of Cloud Data technologies, solutions and future Cloud Data Strategies. Having an understanding of how to build a data model that underpins Machine Learning, Natural Language Processing and automated translation engines is a plus. Be a self-starter who is self-sufficient with a cost-conscious way of working; should have a point of view and speak to data architectures with authority and back it up with detailed technical knowledge and experience. Have a strong experience transforming and mapping business and/or user requirements to logical data requirements for 360 view of customer data to drive value (customer/member personalization). Experience of different IT delivery approaches (Agile, Kanban, Scrum).



RESPONSIBILITIES:



Define, document current state model & deliver a clear & strategic Data Architecture roadmap in alignment with the wider IT organization and APA businesses. Define and manage the overall data architecture & strategic roadmap for APA. Responsible for maximizing value derived from data and analytics; foster value creation using the APA's data assets, as well as the external data ecosystem. Create value through data exploitation, envisioning data-enabled strategies, and enabling all forms of business outcomes through data analytics and governance. Consistently take charge and lead efforts in Conceptual, Logical, and Physical Database architectures, design patterns, best practices, and programming techniques around relational modelling, dimensional modelling and data integration. Identify important potential technologies and approaches to address current and future data needs, evaluating their applicability and fit, as well as leading the definition of standards and best-practice for their use. Work closely with other members of the Enterprise Data Management & Analytics (EDMA) team and other IT partners to ensure they have appropriate access to the data they need ahead of them interrogating and manipulating potentially large data sets. Building comprehensive tests (in integrity, presence and quality) to create confidence in the data we produce and use to increase the trust in our data enterprise-wide. Support others in defining and managing the Architecture and Technology governance processes for APA's Data ecosystem and coach/mentor members of the team to provide technical oversight. Lead and collaborate with other IT partners on Master Data management (MDM), Customer Data Management (CDM), Metadata Management and Data Governance (DG) projects. Responsible for identifying how Information & data can be better used to forward the aims of APA. Undertake the quality assurance of new & developed data structures from new applications and associated components (entity descriptions, relationship descriptions, attribute definitions). Develop detailed knowledge of the appropriate corporate data standards and of the appropriate professional and/or legal data standards. Other duties as assigned.



About APA:


The American Psychological Association (APA) represents 122,000 psychologists, students, and affiliates, primarily in the U.S. and Canada but also in other countries around the world. APA is a scientific and professional organization with about 500 employees and is categorized as a 501(c)(3) along with its 501(c)(6) companion organization, APA Services, Inc.


Job Location: Remote:
APA jobs may be considered for remote work eligibility as defined in APA's Flexible Work Policy and are subject to approval. Remote work employees may not work from the following states or U.S. territories: Alaska, California, Colorado, Guam, Hawaii, Iowa, Louisiana, Montana, Nebraska, New York, North Dakota, Ohio, Puerto Rico, Rhode Island, U.S. Virgin Islands, Washington, Wyoming.


Application Instructions:


Qualified candidates must apply online through APA's applicant system and attach a resume and cover letter specifying your salary expectations. Applications that are submitted without both documents are considered incomplete and will not be reviewed for consideration.
Once your application is submitted, you will receive a confirmation email.
Please make sure to check your Spam folder if you do not receive an email from us.


The American Psychological Association is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, national origin, disability, protected Veteran status, sexual orientation, gender identity, or any other protected categories covered under local law.

APA has a mandatory vaccination policy. All employees must be either fully vaccinated or receive approval from APA for an exemption (disability/medical or sincerely held religious belief) before beginning work at APA. By submitting your application, you agree that as a condition of employment, you must comply with APA's mandatory vaccination policy and other health and safety requirements. #LIRemote

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)