À propos
Core Purpose:
Building enduring relationships and strong communities
Core Values:
Integrity – Do the right thing…always be respectful, honest and fair
Commitment – Take ownership, work hard, and keep promises
Teamwork – Collaborate to foster trust and success for all
Value People – Support each other in a safe, positive environment where people are recognized and appreciated for their contributions
Our Company
For more than a century, Kraus-Anderson has been transforming the American landscape.
Founded in 1897, KA is consistently ranked among the top general contractors in the United States. Our Minnesota base of operations is supplemented with regional offices, extending our capabilities coast to coast. KA is a growing, dynamic organization committed to building a team of professionals who are empowered and inspired to attain their career goals as well as KA’s goals.
We take a highly collaborative approach to our work, engaging in detailed meetings and discussion with owners, architects and the entire planning team well before ground is broken. Our cost analyses, scheduling information, and value engineering services ensure that our client can make informed decisions leading to a timely finish at the highest quality and best value.
Position Summary:
The Database Administrator role will manage and maintain the data environment and data strategy of Kraus-Anderson (KA). This includes monitoring, securing, prioritizing, documenting, extracting and configuring all data to preserve all data integrity and privacy. This position will make sure that the KA environment follows database management best practices as well as cutting edge design and theory. They will also be responsible for creating and managing the landscape and environment for Business Intelligence and Analytics. They will work closely with the VP, IT and other leaders to create a sustainable data environment aligned with the KA application architecture.
Essential Duties and Responsibilities:
Systems & Application Management
Maintains, patches, tunes, and troubleshoots database.
Ensures application performance and tuning.
Maintains and troubleshoots server configuration
Administers, schedules, and tunes applications.
Manages application integration and Application Programming Interface (API).
Assists in database testing, execution, and application patch reviews.
Assists infrastructure team for network and hardware performance issues.
Manages, tunes, and maintains data warehouse.
Data, Reporting & Analytics
Creates and revises data dictionary descriptions, including type, structure, and intended use of data.
Develops data model describing data elements and how they are used.
Creates and tunes custom forms and reports.
Designs and builds application reports and forms.
Provides support, tuning, and configuration of Business Intelligence software (BI).
Governance, Support & Operations
.Assesses and maintains security compliance for National Institute of Standards and Technology (NIST), Cybersecurity Maturity Model Certification (CMMC), and International Organization for Standardization (ISO).
Manages application integration and Application Programming Interface (API).
Defines and validates disaster recovery plans.
Changes control input for impact, audit, and validation purposes.
Prioritizes and schedules problem resolution.
Logs and tracks calls using problem management database, and maintains history records and related problem documentation.
Assists IT management when needed or requested.
Azure Cloud & Platform
Administers and maintains cloud-based database platforms, including Microsoft Azure SQL Managed Instance, Azure SQL Database, and related services.
Designs and supports cloud data architecture, including integration with Azure Data Factory, Azure Storage, and data lake environments.
Monitors and optimizes cloud database performance, scalability, and cost efficiency.
Manages backup, restore, and high availability strategies in cloud environments.
Supports migration of on-premises databases to Azure cloud platforms.
Data Integration & Pipelines
Designs, builds, and maintains ETL/ELT pipelines for data movement and transformation, including Azure Data Factory.
Integrates data from multiple internal and external systems using APIs, cloud services, and data pipelines.
Ensures reliability and performance of data ingestion processes.
Performs other duties as assigned.
Required Knowledge, Skills and Abilities:
Bachelor’s degree in business, IT or equivalent; or equivalent combination of education and experience
1 to 3 years related experience
SQL Database Administrator Certification
1+ Years of Business Intelligence, Analytics and Data Management
2+ years of Enterprise Resource Planning (ERP) support experience
2+ years Structure Query Language (SQL) and custom reporting experience
2+ years of Microsoft O365
Working knowledge of Microsoft PowerBI or equivalent BI software
Demonstrated computer proficiency (MS Office 365 – Word, PowerPoint, Excel and Outlook)
Satisfactory verbal and written communication skills, including ability to effectively communicate with internal and external customers
Ability to work under pressure and meet deadlines, while maintaining a positive attitude and providing exemplary customer service
Strong capabilities managing a business-critical ERP system, requiring appropriate sense of urgency
Strong analytical, troubleshooting, and problem-solving skills
Results oriented work style in a 24x7 application uptime environment
Able to work simultaneously on multiple projects within tight time frames with ability to produce high quality outcomes
Ability to work independently with minimal supervision
Flexible and able to plan for contingencies and know when to invoke them
Strong organizational skills and high level of personal discipline
Able to communicate and collaborate well with technical teams and business Subject Matter Experts (SME)
Experienced and skilled in documenting configurations, architecture, technical processes
Able to work efficiently in a matrix environment
Ability to use time productively, maximize efficiency and meet challenging work goals
Ability to maintain compliance with all company policies and procedures
Ability to possess and maintain exceptional work ethic as well as uphold company values and demand the highest standard of conduct from self and others
Preferred Knowledge, Skills and Abilities:
2+ years of Project Management or Project Implementation
Strong knowledge of IT governance, project planning, and the technological usage/alternatives available in a multi-business unit environment.
Functional knowledge of core business processes such as accounting, construction, inventory management, and the supply chain
Working knowledge of Power BI architecture, including datasets, semantic models, and data refresh processes.
Working knowledge of Power Automate flows, including triggers, actions, and integration with data sources.
Familiarity with Microsoft Fabric concepts, including Lakehouse, Warehouse, and data pipelines.
Understanding of how traditional databases integrate with data lake and lakehouse architectures.
Working knowledge of REST APIs and how data is exchanged between systems.
Understanding of JSON, data payloads, and integration patterns used in modern applications.
Microsoft Certified: Azure Database Administrator Associate
Other:
Ability to travel to jobsites and Non-Metro offices as necessary
Physical Demands:
The physical demands described are representative of those that must be met by any employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Essential functions include items such as ability to:
Clearly communicate information (both written and verbal) to colleagues and key stakeholders
Stand and/or sit in a stationary position for extended periods of time; 50%+ Use a computer/laptop/iPad in open office environment with natural and/or florescent lighting
Navigate between office building floors, and on occasion, attend off-site meetings
Lift up to 25 lbs. unassisted
Salary Range:
$95,000 to $115,000 annually, plus discretionary incentive program.
While the range listed represents the anticipated hiring range for this position, offers at the upper end of the range are uncommon.
Pay is based on many factors including but not limited to education, skill, experience, training, certifications, and other business needs.
Why KA?
We offer a challenging, rewarding, and supportive environment where employees are positioned to make a positive impact on our business, our communities, and their own future.
We believe in building leaders. KA offers a wide range of enrichment and professional growth opportunities through KA University (https://www.krausanderson.com/the-company/kau/) and community service opportunities through our KA Has Heart Volunteer Program.
KA offers full time employees (30+ hours) a significant Total Rewards package including:
Medical insurance Plan Options
Health Savings Accounts (HSA)
Flex Spending Accounts (FSA)
Wellness Program
KA University Training and Development
Fitness Center, KA corporate headquarters, Minneapolis
401(k) Plan
Company sponsored Short Term and Long Term Disability
Company sponsored Life/Accidental Death and Dismemberment Insurance
Time Off including vacation, sick and holiday pay
Workplace Flexibility
Paid Parental Leave
Paid Military Leave for Active Reserve Duty
Free Parking
Along with our employer sponsored plans, we also offer an array of Voluntary Benefits and other perks.
Make A Positive Impact
EOE/ Vets/ Disabled
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.